home *** CD-ROM | disk | FTP | other *** search
/ CD BIT 75 / CD BIT 75.iso / Software / mysql-4.0.22-win / data1.cab / Development / sql-bench / Results / RUN-mysql-Linux_2.0.35_i686-cmp-adabas,mysql < prev    next >
Encoding:
Text File  |  2004-10-28  |  3.3 KB  |  61 lines
  1. Benchmark DBD suit:  2.0
  2. Date of test:        1998-10-20  6:54:10
  3. Running tests on:    Linux 2.0.35 i686
  4. Arguments:           --small-tables
  5. Comments:            pentiumpro 400mz x2, 256M, SCSI, pgcc compiled, key_cache=1M
  6. Limits from:         adabas,mysql
  7. Server version:      MySQL 3.22.9 beta
  8.  
  9. ATIS: Total time: 75 secs ( 6.54 usr 21.70 sys = 28.24 cpu)
  10. alter-table: Total time: 39 secs ( 0.08 usr  0.33 sys =  0.41 cpu)
  11. big-tables: Total time: 17 secs ( 3.29 usr  6.92 sys = 10.21 cpu)
  12. connect: Total time: 134 secs (17.63 usr 95.64 sys = 113.27 cpu)
  13. create: Total time: 19 secs ( 0.75 usr  1.48 sys =  2.23 cpu)
  14. insert: Total time: 229 secs (30.40 usr 67.93 sys = 98.33 cpu)
  15. select: Estimated total time: 1075 secs (23.53 usr 69.27 sys = 92.80 cpu)
  16. wisconsin: Total time: 30 secs ( 3.27 usr  5.49 sys =  8.76 cpu)
  17.  
  18. All 8 test executed successfully
  19. Tests with estimated time have a + at end of line
  20.  
  21. Totals per operation:
  22. Operation             seconds     usr     sys     cpu   tests
  23. alter_table_add            21    0.03    0.08    0.11     246
  24. alter_table_drop           15    0.02    0.11    0.13     123
  25. connect                    53    6.27   42.43   48.70   10000
  26. connect+select             59    8.21   42.61   50.82   10000
  27. count                       7    0.01    0.06    0.07     100
  28. count_on_key              816   10.62   28.10   38.72   50100 +
  29. create+drop                 3    0.24    0.33    0.57    1000
  30. create_index                2    0.00    0.00    0.00       8
  31. create_key+drop             3    0.11    0.69    0.80    1000
  32. create_table                7    0.32    0.13    0.45    1031
  33. delete_big                 11    0.02    0.01    0.03      15
  34. delete_key                  0    0.00    0.04    0.04     500
  35. drop_index                  1    0.00    0.00    0.00       8
  36. drop_table                  0    0.07    0.12    0.19    1028
  37. insert                     46    4.94    7.46   12.40   80768
  38. insert_duplicates           4    0.00    1.39    1.39   30000
  39. insert_key                 15    0.72    1.30    2.02   10000
  40. insert_many_fields          4    0.43    0.25    0.68    2000
  41. min_max                     4    0.00    0.08    0.08      60
  42. min_max_on_key            233   11.76   38.73   50.49   73000
  43. order_by                   10    2.24    6.64    8.88      10
  44. order_by_key                6    1.44    4.75    6.19      10
  45. select                     12    0.79    5.75    6.54   20000
  46. select_big                 18    4.43    9.37   13.80   10080
  47. select_distinct            20    0.92    3.98    4.90     800
  48. select_group               24    0.85    2.84    3.69    3401
  49. select_join                34    3.85   12.82   16.67     200
  50. select_key                 25    5.64   11.36   17.00   20000
  51. select_key_prefix          27    6.22   11.03   17.25   20000
  52. select_many_fields         13    2.84    6.67    9.51    2000
  53. select_range               60    5.59   13.95   19.54   25420
  54. select_range_prefix        40    4.40   11.13   15.53   25010
  55. select_simple_join          3    0.50    1.29    1.79     500
  56. update_key                  1    0.05    0.07    0.12     500
  57. update_key_big              4    0.03    0.04    0.07     480
  58. update_of_key               7    0.02    0.04    0.06     256
  59. wisc_benchmark              9    1.84    2.92    4.76     114
  60. TOTALS                   1617   85.42  268.57  353.99  399768 +
  61.